﻿using STHPMS1.DAL.D_Core;
using STHPMS1.ICore.I_DAL.Repository;
using System.Data;
using System.Data.SqlClient;

namespace STHPMS1.DAL.D_Repository
{
    public class Dr_RepaircostRepository : DalBase, IDr_RepaircostRepository
    {
        public DataTable GetComparePlan(string proj_Id)
        {
            string sql = string.Format(@"select l.INIPROJ_ID,l.MEAS_NAME, MAIN_YEAR, MAINTYPE FROM DR_REPAIRCOST i
	JOIN DR_LARGEMEAS_INI l
	on i.INIPROJ_ID=l.INIPROJ_ID
    where i.PROJ_ID='{0}'
    ORDER BY INIPROJ_ID ;", proj_Id);


            return Adapter.DataAdapter.FillDataTable(sql);
        }
    }
}
